package jpa.entitys.promis.sales;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;

import jpa.entitys.common.CommonEntity;


/**
 * The persistent class for the XFR_OF_OWNERSHIP_DETAILS database table.
 * 
 */
@Entity
@Table(name="XFR_OF_OWNERSHIP_DETAILS")
@NamedQueries({
    @NamedQuery(name = "XfrOfOwnershipDetail.findAll", query = " SELECT c FROM XfrOfOwnershipDetail c "),
    @NamedQuery(name = "XfrOfOwnershipDetail.findById", query = " SELECT c FROM XfrOfOwnershipDetail c WHERE c.id = :Id "),
    @NamedQuery(name = "XfrOfOwnershipDetail.findByStaging", query = " SELECT c FROM XfrOfOwnershipDetail c WHERE c.syncIsstaging = :syncIsstaging"),
    @NamedQuery(name = "XfrOfOwnershipDetail.findByDocumentNo", query = " SELECT c FROM XfrOfOwnershipDetail c WHERE c.id.company = :company And c.id.project = :project And c.id.voucherType = :voucherType And c.id.voucherSeries = :voucherSeries And c.id.voucherNumber = :voucherNumber And c.revisionNumber = :revisionNumber And c.id.flagChargeType = :flagChargeType And c.utilityFlag = :utilityFlag order by c.id.company,c.id.project ,c.id.voucherType,c.id.voucherSeries,c.id.voucherNumber,c.revisionNumber,c.id.seqNo asc")
})
public class XfrOfOwnershipDetail extends CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@EmbeddedId
	private XfrOfOwnershipDetailPK id;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	private BigDecimal amount;

	@Column(name="AMOUNT_CASH")
	private BigDecimal amountCash;

	@Column(name="AMOUNT_CHEQUE")
	private BigDecimal amountCheque;

	@Column(name="AMOUNT_PAID")
	private BigDecimal amountPaid;

	@Column(name="BUILDING_PHASE_CODE")
	private String buildingPhaseCode;

	@Column(name="BUYER_PAY")
	private BigDecimal buyerPay;

	@Column(name="CHARGE_AMOUNT")
	private BigDecimal chargeAmount;

	@Column(name="CHARGE_CODE")
	private String chargeCode;

	@Column(name="CHARGE_PER_SQ")
	private String chargePerSq;

	@Column(name="CHEQUE_PAYEE_AC")
	private String chequePayeeAc;

	@Column(name="CONDITION_CHARGE")
	private String conditionCharge;

	@Column(name="CREATED_BY")
	private String createdBy;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="CREATED_ON")
	private Date createdOn;

	@Column(name="EXPENSE_GROUP")
	private String expenseGroup;

	@Column(name="FINE_FLAG")
	private String fineFlag;

	@Column(name="FLAG_PAY")
	private String flagPay;

	@Column(name="FLOOR_ZONE_CODE")
	private String floorZoneCode;

	@Column(name="FROM_PRICE")
	private String fromPrice;

	@Column(name="INCLUDED_VAT_FLAG")
	private String includedVatFlag;

	@Column(name="LAST_UPDATED_BY")
	private String lastUpdatedBy;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="LAST_UPDATED_ON")
	private Date lastUpdatedOn;

	@Column(name="NET_AMOUNT")
	private BigDecimal netAmount;

	@Column(name="NET_AMT_IN_UNIT")
	private BigDecimal netAmtInUnit;

	@Column(name="NET_AMT_OUT_UNIT")
	private BigDecimal netAmtOutUnit;

	@Column(name="NO_OF_PER")
	private BigDecimal noOfPer;

	@Column(name="PAID_AMOUNT")
	private BigDecimal paidAmount;

	@Column(name="PAY_BY")
	private String payBy;

	@Column(name="PER_VALUES")
	private String perValues;

	@Column(name="PROPERTY_TYPE_CODE")
	private String propertyTypeCode;

	@Column(name="PURCHASE_ORDERS_ID")
	private String purchaseOrdersId;

	private String remarks;

	@Column(name="REVISION_NUMBER")
	private BigDecimal revisionNumber;

	@Column(name="SELLER_PAY")
	private BigDecimal sellerPay;

	private String status;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_EXTERNAL_REF_KEY")
	private String syncExternalRefKey;

	@Column(name="SYNC_EXTERNAL_REF_NO")
	private String syncExternalRefNo;

	@Column(name="SYNC_ISSTAGING")
	private String syncIsstaging;

	@Column(name="SYNC_ISSYNC")
	private String syncIssync;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TAX_TYPE_CODE")
	private String taxTypeCode;

	@Column(name="TOTAL_CHARGE")
	private BigDecimal totalCharge;

	@Column(name="TOTAL_PERIOD")
	private String totalPeriod;

	@Column(name="UNIT_NUMBER")
	private String unitNumber;

	@Column(name="VALUE_RATE")
	private BigDecimal valueRate;

	@Column(name="VAT_AMOUNT")
	private BigDecimal vatAmount;

	@Column(name="VAT_CODE")
	private String vatCode;

	@Column(name="VAT_PERCENT")
	private BigDecimal vatPercent;

	@Column(name="WHT_AMOUNT")
	private BigDecimal whtAmount;

	@Column(name="WHT_PERCENT")
	private BigDecimal whtPercent;

	@Column(name="WHT_SUBCODE")
	private String whtSubcode;
	
	@Column(name="UTILITY_FLAG")
	private String utilityFlag;
	
    /**
	 * @return the utilityFlag
	 */
	public String getUtilityFlag() {
		return utilityFlag;
	}

	/**
	 * @param utilityFlag the utilityFlag to set
	 */
	public void setUtilityFlag(String utilityFlag) {
		this.utilityFlag = utilityFlag;
	}

	public XfrOfOwnershipDetail() {
    }

	public XfrOfOwnershipDetailPK getId() {
		return this.id;
	}

	public void setId(XfrOfOwnershipDetailPK id) {
		this.id = id;
	}
	
	public BigDecimal getAmount() {
		return this.amount;
	}

	public void setAmount(BigDecimal amount) {
		this.amount = amount;
	}

	public BigDecimal getAmountCash() {
		return this.amountCash;
	}

	public void setAmountCash(BigDecimal amountCash) {
		this.amountCash = amountCash;
	}

	public BigDecimal getAmountCheque() {
		return this.amountCheque;
	}

	public void setAmountCheque(BigDecimal amountCheque) {
		this.amountCheque = amountCheque;
	}

	public BigDecimal getAmountPaid() {
		return this.amountPaid;
	}

	public void setAmountPaid(BigDecimal amountPaid) {
		this.amountPaid = amountPaid;
	}

	public String getBuildingPhaseCode() {
		return this.buildingPhaseCode;
	}

	public void setBuildingPhaseCode(String buildingPhaseCode) {
		this.buildingPhaseCode = buildingPhaseCode;
	}

	public BigDecimal getBuyerPay() {
		return this.buyerPay;
	}

	public void setBuyerPay(BigDecimal buyerPay) {
		this.buyerPay = buyerPay;
	}

	public BigDecimal getChargeAmount() {
		return this.chargeAmount;
	}

	public void setChargeAmount(BigDecimal chargeAmount) {
		this.chargeAmount = chargeAmount;
	}

	public String getChargeCode() {
		return this.chargeCode;
	}

	public void setChargeCode(String chargeCode) {
		this.chargeCode = chargeCode;
	}

	public String getChargePerSq() {
		return this.chargePerSq;
	}

	public void setChargePerSq(String chargePerSq) {
		this.chargePerSq = chargePerSq;
	}

	public String getChequePayeeAc() {
		return this.chequePayeeAc;
	}

	public void setChequePayeeAc(String chequePayeeAc) {
		this.chequePayeeAc = chequePayeeAc;
	}

	public String getConditionCharge() {
		return this.conditionCharge;
	}

	public void setConditionCharge(String conditionCharge) {
		this.conditionCharge = conditionCharge;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public Date getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(Date createdOn) {
		this.createdOn = createdOn;
	}

	public String getExpenseGroup() {
		return this.expenseGroup;
	}

	public void setExpenseGroup(String expenseGroup) {
		this.expenseGroup = expenseGroup;
	}

	public String getFineFlag() {
		return this.fineFlag;
	}

	public void setFineFlag(String fineFlag) {
		this.fineFlag = fineFlag;
	}

	public String getFlagPay() {
		return this.flagPay;
	}

	public void setFlagPay(String flagPay) {
		this.flagPay = flagPay;
	}

	public String getFloorZoneCode() {
		return this.floorZoneCode;
	}

	public void setFloorZoneCode(String floorZoneCode) {
		this.floorZoneCode = floorZoneCode;
	}

	public String getFromPrice() {
		return this.fromPrice;
	}

	public void setFromPrice(String fromPrice) {
		this.fromPrice = fromPrice;
	}

	public String getIncludedVatFlag() {
		return this.includedVatFlag;
	}

	public void setIncludedVatFlag(String includedVatFlag) {
		this.includedVatFlag = includedVatFlag;
	}

	public String getLastUpdatedBy() {
		return this.lastUpdatedBy;
	}

	public void setLastUpdatedBy(String lastUpdatedBy) {
		this.lastUpdatedBy = lastUpdatedBy;
	}

	public Date getLastUpdatedOn() {
		return this.lastUpdatedOn;
	}

	public void setLastUpdatedOn(Date lastUpdatedOn) {
		this.lastUpdatedOn = lastUpdatedOn;
	}

	public BigDecimal getNetAmount() {
		return this.netAmount;
	}

	public void setNetAmount(BigDecimal netAmount) {
		this.netAmount = netAmount;
	}

	public BigDecimal getNetAmtInUnit() {
		return this.netAmtInUnit;
	}

	public void setNetAmtInUnit(BigDecimal netAmtInUnit) {
		this.netAmtInUnit = netAmtInUnit;
	}

	public BigDecimal getNetAmtOutUnit() {
		return this.netAmtOutUnit;
	}

	public void setNetAmtOutUnit(BigDecimal netAmtOutUnit) {
		this.netAmtOutUnit = netAmtOutUnit;
	}

	public BigDecimal getNoOfPer() {
		return this.noOfPer;
	}

	public void setNoOfPer(BigDecimal noOfPer) {
		this.noOfPer = noOfPer;
	}

	public BigDecimal getPaidAmount() {
		return this.paidAmount;
	}

	public void setPaidAmount(BigDecimal paidAmount) {
		this.paidAmount = paidAmount;
	}

	public String getPayBy() {
		return this.payBy;
	}

	public void setPayBy(String payBy) {
		this.payBy = payBy;
	}

	public String getPerValues() {
		return this.perValues;
	}

	public void setPerValues(String perValues) {
		this.perValues = perValues;
	}

	public String getPropertyTypeCode() {
		return this.propertyTypeCode;
	}

	public void setPropertyTypeCode(String propertyTypeCode) {
		this.propertyTypeCode = propertyTypeCode;
	}

	public String getPurchaseOrdersId() {
		return this.purchaseOrdersId;
	}

	public void setPurchaseOrdersId(String purchaseOrdersId) {
		this.purchaseOrdersId = purchaseOrdersId;
	}

	public String getRemarks() {
		return this.remarks;
	}

	public void setRemarks(String remarks) {
		this.remarks = remarks;
	}

	public BigDecimal getRevisionNumber() {
		return this.revisionNumber;
	}

	public void setRevisionNumber(BigDecimal revisionNumber) {
		this.revisionNumber = revisionNumber;
	}

	public BigDecimal getSellerPay() {
		return this.sellerPay;
	}

	public void setSellerPay(BigDecimal sellerPay) {
		this.sellerPay = sellerPay;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncExternalRefKey() {
		return this.syncExternalRefKey;
	}

	public void setSyncExternalRefKey(String syncExternalRefKey) {
		this.syncExternalRefKey = syncExternalRefKey;
	}

	public String getSyncExternalRefNo() {
		return this.syncExternalRefNo;
	}

	public void setSyncExternalRefNo(String syncExternalRefNo) {
		this.syncExternalRefNo = syncExternalRefNo;
	}

	public String getSyncIsstaging() {
		return this.syncIsstaging;
	}

	public void setSyncIsstaging(String syncIsstaging) {
		this.syncIsstaging = syncIsstaging;
	}

	public String getSyncIssync() {
		return this.syncIssync;
	}

	public void setSyncIssync(String syncIssync) {
		this.syncIssync = syncIssync;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getTaxTypeCode() {
		return this.taxTypeCode;
	}

	public void setTaxTypeCode(String taxTypeCode) {
		this.taxTypeCode = taxTypeCode;
	}

	public BigDecimal getTotalCharge() {
		return this.totalCharge;
	}

	public void setTotalCharge(BigDecimal totalCharge) {
		this.totalCharge = totalCharge;
	}

	public String getTotalPeriod() {
		return this.totalPeriod;
	}

	public void setTotalPeriod(String totalPeriod) {
		this.totalPeriod = totalPeriod;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public BigDecimal getValueRate() {
		return this.valueRate;
	}

	public void setValueRate(BigDecimal valueRate) {
		this.valueRate = valueRate;
	}

	public BigDecimal getVatAmount() {
		return this.vatAmount;
	}

	public void setVatAmount(BigDecimal vatAmount) {
		this.vatAmount = vatAmount;
	}

	public String getVatCode() {
		return this.vatCode;
	}

	public void setVatCode(String vatCode) {
		this.vatCode = vatCode;
	}

	public BigDecimal getVatPercent() {
		return this.vatPercent;
	}

	public void setVatPercent(BigDecimal vatPercent) {
		this.vatPercent = vatPercent;
	}

	public BigDecimal getWhtAmount() {
		return this.whtAmount;
	}

	public void setWhtAmount(BigDecimal whtAmount) {
		this.whtAmount = whtAmount;
	}

	public BigDecimal getWhtPercent() {
		return this.whtPercent;
	}

	public void setWhtPercent(BigDecimal whtPercent) {
		this.whtPercent = whtPercent;
	}

	public String getWhtSubcode() {
		return this.whtSubcode;
	}

	public void setWhtSubcode(String whtSubcode) {
		this.whtSubcode = whtSubcode;
	}

}